import openpyxl

myBook=openpyxl.load_workbook('工资表.xlsx',data_only=True)
mySheet=myBook['工资表']
for myRow in range(mySheet.max_row,2,-1):
	mySheet.insert_rows(myRow)
	for myCol in range(1,8):
		mySheet.cell(myRow,myCol,mySheet.cell(1,myCol).value)
	mySheet.insert_rows(myRow)

myBook.save('结果表-工资表.xlsx')

